Title not appear in formula bar due to title centered across cells.
Cause:
This behavior occurs because the title is centered across multiple cells in the row.
Solution:
Select the row that the title is on, and turn off the 'Center across selection' option in the 'Format Cells' dialog box.
1) Click on the row number to the left of the row. (The entire row is highlighted.)
2) Select the 'Format' menu and select 'Cells...'. (The Format Cells dialog box appears.)
3) Click the 'Alignment' tab.
4) Select the 'Left' radio button in the 'Horizontal' group.
5) Click 'OK'. (The 'Format Cells' dialog box closes.)
6) Select the cell in which the title appears. (The title appears in the formula bar.)
